An Automatic Domain Independent Schema Matching in Integrating Schemas of Heterogeneous Relational Databases

نویسندگان

  • Hamidah Ibrahim
  • Yaser Karasneh
  • Meghdad Mirabi
  • Razali Yaakob
  • Mohamed Othman
چکیده

Schema matching is one of the key challenges in the process of integrating heterogeneous databases which identifies the correspondences among different elements of databases’ schemas. There are several semi-automatic schema matching algorithms, however these algorithms do not exploit most of the available information related to schemas during the process of schema matching which affects on the accuracy of schema matching result. In this paper, we proposed a domain independent schema matching approach which utilized both the structural and semantic information during the process of schema matching and offered database integration without user intervention. In order to ensure the correctness of our proposed approach, we provide a proof on the validation of our proposed approach in terms of maintaining the properties of the initial input schemas as well as the characteristics of the relational model. In comparison with previous approaches, our proposed approach produced better global schemas during integration process.

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

منابع مشابه

Matching of XML Schemas and Relational Schemas

XML is widely used for data exchange between relational databases. Generic exchange tools are based on mappings between the elements of both schemas. Despite the benefits of using generic tools, the manual definition of the mappings can become a time consuming and error-prone task. Given this scenario we propose algorithms for the automatic matching of XML schemas(DTDs) and relational schemas. ...

متن کامل

An Approach for Matching Schemas of Heterogeneous Relational Databases

AbstrAct: Schema matching is a basic problem in many database application domains, such as data integration. The problem of schema matching can be formulated as follows, " given two schemas, S i and S j , find the most plausible correspondences between the elements of S i and S j , exploiting all available information, such as the schemas, instance data, and auxiliary sources " [24]. Given the ...

متن کامل

An Interactive Tool Based on Xml Technology for Data Exchange between Heterogeneous Erp Systems

Data exchange between enterprise resource planning (ERP) systems in a supply chain system needs to fulfill requirements of both schema integration and message translation. Since ERP systems with relational database systems are developed independently, schema conflicts between databases is a common problem for schema integration. Thus, supply chain partners need to preserve the data integrity of...

متن کامل

Semantic Integration of Heterogeneous Databases in Multidatabase System

Establishing semantic interoperability among heterogeneous information sources is becoming a critical issue in the database community with the increase in both the amount of data and the number of data producers. One of the challenging problems in the multidatabase systems is to find the most viable solution to the problem of interoperability of distributed heterogeneous autonomous local compon...

متن کامل

Database Conceptual Schema Matching

Schema matching is a critical step in integration of heterogeneous data sources. properties and/or include other concepts and having Database. a novel, semi-automated and generic schema matching process. Prison Break solves the established practice (5), widely used for database migration and ontology where similar domain concepts may not be be identifiable via linguistic. Database / Oracle Data...

متن کامل

ذخیره در منابع من


  با ذخیره ی این منبع در منابع من، دسترسی به آن را برای استفاده های بعدی آسان تر کنید

برای دانلود متن کامل این مقاله و بیش از 32 میلیون مقاله دیگر ابتدا ثبت نام کنید

ثبت نام

اگر عضو سایت هستید لطفا وارد حساب کاربری خود شوید

عنوان ژورنال:
  • J. Inf. Sci. Eng.

دوره 30  شماره 

صفحات  -

تاریخ انتشار 2014